Create Difference Reports

A Difference Report compares the differences between the Master and the Replica at a certain point in time. The comparison is performed using the same algorithms that are used in the synchronization process, but no data is transferred. A Difference Report is generated for each Replica and sent to the Manager at the end of the process. This can be produced at any time.

Note: When you run a difference report on a SQL Server 2008/Windows Server 2008 R2 platform, differences are reported due to way in which SQL Server 2008 pre-allocates buffer size. This difference does not impact database integrity.

Important! We do not recommend initiating the Difference Report when data is being updated on the Master, since all updates that are not yet applied to the Replica will be shown as difference.

To create difference reports

  1. Click the Difference Report icon on the Standard toolbar, or select from the Tools menu the Report, Difference report option.
  2. The Difference report dialog opens with the same comparison methods as in the Synchronization method dialog.
  3. Choose the desired options, according to the instructions specified in How Synchronization Works.
  4. Click OK.
  5. At the end of the process, a Difference Report is generated for each replica, and all the reports are sent to the Report Center.